Data Grouping Process in Extended SQL Language Containing Fuzzy Elements

نویسندگان

  • Bozena Malysiak-Mrozek
  • Dariusz Mrozek
  • Stanislaw Kozielski
چکیده

Incorporation of fuzziness into database systems allows to expand the analysis of data during the querying process. Approximate processing of data includes not only rows that exactly meet the search criteria, but also rows that are similar with the given range of tolerance. Queries formulated in natural language usually consist of imprecise and fuzzy terms. However, the implementation of the imprecision in query languages, such as SQL, requires additional extensions in a target database system. In the paper, we devote our attention to different methods of data grouping. In the first part of the paper we concentrate on the process of fuzzy grouping of crisp data. In the second part, we focus on the grouping of fuzzy data.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Processing of Crisp and Fuzzy Measures in the Fuzzy Data Warehouse for Global Natural Resources

Fuzzy Data Warehouse (FDW) is a data repository, which contains fuzzy data and allows fuzzy processing of the data. Incorporation of fuzziness into data warehouse systems gives the opportunity to process data at higher level of abstraction and improves the analysis of imprecise data. It also gives the possibility to express business indicators in natural language using terms, like: high, low, a...

متن کامل

Efficient Processing of Nested Fuzzy SQL Queries in a Fuzzy Database

ÐIn a fuzzy relational database where a relation is a fuzzy set of tuples and ill-known data are represented by possibility distributions, nested fuzzy queries can be expressed in the Fuzzy SQL language, as defined in [25], [23]. Although it provides a very convenient way for users to express complex queries, a nested fuzzy query may be very inefficient to process with the naive evaluation meth...

متن کامل

DATA ENGINEERII { G A publication of the IEEE Computer Society EEE TRANSACTIONS ON

ln a fuzzy relational database where a relation is atuzzy sel of tuples and ill-known data are represented by possibility distributions, nested fuzzy queries can be expressed in lhe Fuzzy SQL language, as defined in [25], [23]. Although it provides a very convenient way for users to express complex queries, a nested fuzzy query may be very inefficient to process with the naive evaluation method...

متن کامل

Sorting, Grouping and Duplicate Elimination in the Advanced Information Management Prototype

Sorting, duplicate suppression and grouping are important operations in relational database management systems. This paper is devoted to the related language features and their implementation in the Advanced Information Management Prototype AIM-P. The query language HDBL is an SQL-like database language supporting the extended NF* data model. The proposed language extensions follow the classica...

متن کامل

Prioritized fuzzy logic based information processing in relational databases

Many years of research related to fuzzy logic and fuzzy set theory extensions to relational databases have not lead to stable implementations, standardized languages or fuzzy relational database application development tools and methods. The main goal of this paper is the modelling and the implementation of a set of tools that allow usage of fuzzy logic enriched with priorities in relational da...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2009